package edu.nf.dao.impl;



import edu.nf.SQLExecutor;
import edu.nf.beans.annotations.Component;
import edu.nf.dao.FindCompleteEmpInfoByIdDao;
import edu.nf.handler.MapHandler;
import edu.nf.utils.DBUtil;

import java.util.Map;

@Component("findCompleteEmpInfoByIdDao")
public class FindCompleteEmpInfoByIdDaoImpl implements FindCompleteEmpInfoByIdDao {


    @Override
    public Map<String, Object> findCompleteEmpInfoById(String empId) {
        String sql = "SELECT EMP_ID,EMP_NAME,EMP_SEX,DEPARTM_ID FROM emp_info S INNER JOIN departm_info C ON e.EMP_DEPARTM=d.DEPARTM_ID INNER JOIN ID ON  WHERE STU_ID = ?";
        SQLExecutor se = new SQLExecutor(DBUtil.getConnection());
        MapHandler handler = new MapHandler();
        return se.executeQuery(sql, handler, empId);
    }
}
